{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"read":"whole","date_system":"1900"}

{"sheet":"Лист1","index":0,"n_rows":203,"n_cols":12,"rows_kept":203,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[24,2,24,3],[43,2,43,3],[63,2,63,3],[82,2,82,3],[103,2,103,3],[123,2,123,3],[142,2,142,3],[162,2,162,3],[181,2,181,3],[201,2,201,3],[202,2,202,4]]}
["Школа",null,"МБОУ \"ИСОШ\" Лаишевского МР РТ",null,null,"Утвердил:","должность","Директор школы"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Шаймухаметова А.М."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",1,9,2025]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор. блюдо","Тефтели куриные  \"Лакомка\"в соусе для запекания",90,10,12,20,208,"ТТК 2020"]
[{"$nulls":3},"гор. блюдо","Каша гречневая рассыпчатая",150,7,5,36,200,"302/2015"]
[{"$nulls":3},"напиток","Напиток из вишни",200,0,0,11,48,"ТТК 2023 "]
[{"$nulls":3},"хлеб ","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничн.)",40,3,0,19,91]
[{"$nulls":3},"фрукты","Плоды и ягоды свежие ( яблоки)",100,0,0,9,39,"338/2015"]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F13)","v":580},{"$f":"SUM(G6:G13)","v":20},{"$f":"SUM(H6:H13)","v":17},{"$f":"SUM(I6:I13)","v":95},{"$f":"SUM(J6:J13)","v":586},null,69.43]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F15:F23)","v":0},{"$f":"SUM(G15:G23)","v":0},0,0,0,null,{"$f":"SUM(L15:L23)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F14+F24","v":580},{"$f":"G14+G24","v":20},17,95,586,null,{"$f":"L14+L24","v":69.43}]
[1,2,"Завтрак","гор. блюдо","Фрикассе из куриных грудок",90,8,9,2,120,"ТТК 2021 "]
[{"$nulls":3},"гор. блюдо","Каша рисовая вязкая",150,4,6,29,190,"303/2015"]
[{"$nulls":3},"гор.напиток ","Чай с сахаром,лимоном",213,0,0,8,34,"ТТК 2021 г"]
[{"$nulls":3},"хлеб ","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничн.)",55,4,0,26,126]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F26:F32)","v":508},{"$f":"SUM(G26:G32)","v":16},{"$f":"SUM(H26:H32)","v":15},{"$f":"SUM(I26:I32)","v":65},{"$f":"SUM(J26:J32)","v":470},null,69.43]
[{"$f":"A26","v":1},{"$f":"B26","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F34:F42)","v":0},{"$f":"SUM(G34:G42)","v":0},{"$f":"SUM(H34:H42)","v":0},{"$f":"SUM(I34:I42)","v":0},{"$f":"SUM(J34:J42)","v":0},null,0]
[{"$f":"A26","v":1},{"$f":"B26","v":2},"Итого за день:",null,null,{"$f":"F33+F43","v":508},{"$f":"G33+G43","v":16},{"$f":"H33+H43","v":15},{"$f":"I33+I43","v":65},{"$f":"J33+J43","v":470},null,69.43]
[1,3,"Завтрак","гор. блюдо","Сосиски отварные с соусом для запекания",90,9,10,9,157,"243/2015"]
[{"$nulls":3},"гор. блюдо","Картофель запеченный (из сырого)",150,4,8,28,202,"ТТК "]
[{"$nulls":3},"гор.напиток ","Чай с сахаром",208,0,0,8,32,"ТТК 2021"]
[{"$nulls":3},"хлеб ","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничн.)",40,3,0,19,91]
[{"$nulls":3},"закуска","Овощи натуральные свежие (огурцы)",60,0,0,1,4,"71/2015"]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F45:F52)","v":548},{"$f":"SUM(G45:G52)","v":16},{"$f":"SUM(H45:H52)","v":18},{"$f":"SUM(I45:I52)","v":65},{"$f":"SUM(J45:J52)","v":486},null,69.43]
[{"$f":"A45","v":1},{"$f":"B45","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F54:F62)","v":0},{"$f":"SUM(G54:G62)","v":0},{"$f":"SUM(H54:H62)","v":0},{"$f":"SUM(I54:I62)","v":0},{"$f":"SUM(J54:J62)","v":0},null,0]
[{"$f":"A45","v":1},{"$f":"B45","v":3},"Итого за день:",null,null,{"$f":"F53+F63","v":548},{"$f":"G53+G63","v":16},{"$f":"H53+H63","v":18},{"$f":"I53+I63","v":65},{"$f":"J53+J63","v":486},null,69.43]
[1,4,"Завтрак","гор. блюдо","Плов с говядиной",190,13,14,35,324,"ТТК 2021 "]
[{"$nulls":3},"гор.напиток ","Чай с сахаром, лимоном",213,0,0,8,34,"ТТК 2021 "]
[{"$nulls":3},"хлеб ","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничн.)",40,3,0,19,91]
[{"$nulls":3},"закуска","Салат пестрый",60,0,3,7,57,"84/2013"]
[]
[{"$nulls":11},69.43]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F65:F71)","v":503},{"$f":"SUM(G65:G71)","v":16},{"$f":"SUM(H65:H71)","v":17},{"$f":"SUM(I65:I71)","v":69},{"$f":"SUM(J65:J71)","v":506},null,{"$f":"SUM(L65:L71)","v":69.43}]
[{"$f":"A65","v":1},{"$f":"B65","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F73:F81)","v":0},{"$f":"SUM(G73:G81)","v":0},{"$f":"SUM(H73:H81)","v":0},{"$f":"SUM(I73:I81)","v":0},{"$f":"SUM(J73:J81)","v":0},null,0]
[{"$f":"A65","v":1},{"$f":"B65","v":4},"Итого за день:",null,null,{"$f":"F72+F82","v":503},{"$f":"G72+G82","v":16},{"$f":"H72+H82","v":17},{"$f":"I72+I82","v":69},{"$f":"J72+J82","v":506},null,69.43]
[1,5,"Завтрак","гор. блюдо","Фрикассе из куриных грудок",90,8,9,2,119,"ТТК 2021 "]
[{"$nulls":3},"гор. блюдо","Макаронные изделия отварные ",150,6,5,36,212,"309/2015"]
[{"$nulls":3},"напиток ","Напиток из вишни",200,0,0,11,48,"ТТК 2023"]
[{"$nulls":3},"хлеб ","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничн.)",40,3,0,19,91]
[{"$nulls":3},"закуска","Салат из моркови с яблоками",60,0,6,5,79,"2001-10-01"]
[]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F84:F92)","v":540},{"$f":"SUM(G84:G92)","v":17},{"$f":"SUM(H84:H92)","v":20},{"$f":"SUM(I84:I92)","v":73},{"$f":"SUM(J84:J92)","v":549},null,69.43]
[{"$f":"A84","v":1},{"$f":"B84","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F94:F102)","v":0},{"$f":"SUM(G94:G102)","v":0},{"$f":"SUM(H94:H102)","v":0},{"$f":"SUM(I94:I102)","v":0},{"$f":"SUM(J94:J102)","v":0},null,0]
[{"$f":"A84","v":1},{"$f":"B84","v":5},"Итого за день:",null,null,{"$f":"F93+F103","v":540},{"$f":"G93+G103","v":17},{"$f":"H93+H103","v":20},{"$f":"I93+I103","v":73},{"$f":"J93+J103","v":549},null,69.43]
[2,1,"Завтрак","гор. блюдо","Гуляш из говядины",90,11,12,2,160,"260/2015"]
[{"$nulls":3},"гор. блюдо","Макаронные изделия отварные ",150,6,5,36,212,"309/2015"]
[{"$nulls":3},"гор.напиток","Чай с сахаром,лимоном",213,0,0,8,34,"ТТК 2021"]
[{"$nulls":3},"хлеб ","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничн.)",50,3,0,23,96]
[]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F105:F112)","v":503},{"$f":"SUM(G105:G112)","v":20},{"$f":"SUM(H105:H112)","v":17},{"$f":"SUM(I105:I112)","v":69},{"$f":"SUM(J105:J112)","v":502},null,69.43]
[{"$f":"A105","v":2},{"$f":"B105","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F114:F122)","v":0},{"$f":"SUM(G114:G122)","v":0},0,0,0,null,{"$f":"SUM(L114:L122)","v":0}]
[{"$f":"A105","v":2},{"$f":"B105","v":1},"Итого за день:",null,null,{"$f":"F113+F123","v":503},{"$f":"G113+G123","v":20},{"$f":"H113+H123","v":17},{"$f":"I113+I123","v":69},{"$f":"J113+J123","v":502},null,69.43]
[2,2,"Завтрак","гор. блюдо","Жаркое из птицы (грудки куриные)",190,13,14,31,302,"ТТК 2023"]
[{"$nulls":3},"гор.напиток","Чай с сахаром,лимоном",213,0,0,8,34,"ТТК 2021"]
[{"$nulls":3},"хлеб ","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничн.)",40,3,0,19,91]
[{"$nulls":3},"закуска","Салат из  моркови",60,0,3,7,58,"ТТК"]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F125:F130)","v":503},{"$f":"SUM(G125:G130)","v":16},{"$f":"SUM(H125:H130)","v":17},{"$f":"SUM(I125:I130)","v":65},{"$f":"SUM(J125:J130)","v":485},null,69.43]
[{"$f":"A125","v":2},{"$f":"B125","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F133:F141)","v":0},{"$f":"SUM(G133:G141)","v":0},0,0,0,null,{"$f":"SUM(L133:L141)","v":0}]
[{"$f":"A125","v":2},{"$f":"B125","v":2},"Итого за день:",null,null,{"$f":"F132+F142","v":503},{"$f":"G132+G142","v":16},{"$f":"H132+H142","v":17},{"$f":"I132+I142","v":65},{"$f":"J132+J142","v":485},null,69.43]
[2,3,"Завтрак","гор. блюдо","Пельмени \"Для умников и умниц\" отварные с соусом для запекания",185,16,14,44,366,"ТТК 2015"]
[{"$nulls":3},"гор.напиток ","Чай с сахаром, лимоном",213,0,0,8,34,"ТТК 2021 "]
[{"$nulls":3},"хлеб ","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничн.)",45,3,0,21,102]
[{"$nulls":3},"закуска","Салат из свеклы отварной (с маслом)",60,0,4,5,56,"52/2015"]
[]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F144:F151)","v":503},{"$f":"SUM(G144:G151)","v":19},{"$f":"SUM(H144:H151)","v":18},{"$f":"SUM(I144:I151)","v":78},{"$f":"SUM(J144:J151)","v":558},null,69.43]
[{"$f":"A144","v":2},{"$f":"B144","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F153:F161)","v":0},{"$f":"SUM(G153:G161)","v":0},0,0,0,null,{"$f":"SUM(L153:L161)","v":0}]
[{"$f":"A144","v":2},{"$f":"B144","v":3},"Итого за день:",null,null,{"$f":"F152+F162","v":503},{"$f":"G152+G162","v":19},{"$f":"H152+H162","v":18},{"$f":"I152+I162","v":78},{"$f":"J152+J162","v":558},null,69.43]
[2,4,"Завтрак","гор. блюдо","Фрикассе из куриных грудок",90,8,9,2,119,"ТТК 2021 "]
[{"$nulls":3},"гор. блюдо","Каша гречневая рассыпчатая",150,7,6,36,215,"302/2015"]
[{"$nulls":3},"напиток","Напиток из шиповника",200,0,0,10,41,"ТТК 2021 "]
[{"$nulls":3},"хлеб ","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничн.)",40,3,0,19,91]
[{"$nulls":3},"закуска","Овощи натуральные свежие(помидоры)",60,0,0,1,4,"ТТК 2021 "]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F164:F169)","v":540},{"$f":"SUM(G164:G169)","v":18},{"$f":"SUM(H164:H169)","v":15},{"$f":"SUM(I164:I169)","v":68},{"$f":"SUM(J164:J169)","v":470},null,69.43]
[{"$f":"A164","v":2},{"$f":"B164","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F172:F180)","v":0},{"$f":"SUM(G172:G180)","v":0},0,0,0,null,{"$f":"SUM(L172:L180)","v":0}]
[{"$f":"A164","v":2},{"$f":"B164","v":4},"Итого за день:",null,null,{"$f":"F171+F181","v":540},{"$f":"G171+G181","v":18},{"$f":"H171+H181","v":15},{"$f":"I171+I181","v":68},{"$f":"J171+J181","v":470},null,69.43]
[2,5,"Завтрак","гор. блюдо","Тефтели куриные  \"Лакомка\"в соусе для запекания",90,10,12,5,184,"ТТК 2020"]
[{"$nulls":3},"гор. блюдо","Макаронные изделия отварные ",150,6,5,36,200,"309/2015"]
[{"$nulls":3},"гор.напиток","Чай с сахаром",208,0,0,8,32,"ТТК 2021"]
[{"$nulls":3},"хлеб ","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничн.)",40,3,0,19,91]
[{"$nulls":3},"сладкое","Вафли весовые 1 шт/",21,3,2,13,80]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F183:F190)","v":509},{"$f":"SUM(G183:G190)","v":22},{"$f":"SUM(H183:H190)","v":19},{"$f":"SUM(I183:I190)","v":81},{"$f":"SUM(J183:J190)","v":587},null,69.43]
[{"$f":"A183","v":2},{"$f":"B183","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F192:F200)","v":0},{"$f":"SUM(G192:G200)","v":0},0,0,0,null,{"$f":"SUM(L192:L200)","v":0}]
[{"$f":"A183","v":2},{"$f":"B183","v":5},"Итого за день:",null,null,{"$f":"F191+F201","v":509},{"$f":"G191+G201","v":22},{"$f":"H191+H201","v":19},{"$f":"I191+I201","v":81},{"$f":"J191+J201","v":587},null,69.43]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F25+F44+F64+F83+F104+F124+F143+F163+F182+F202)/(IF(F25=0,0,1)+IF(F44=0,0,1)+IF(F64=0,0,1)+IF(F83=0,0,1)+IF(F104=0,0,1)+IF(F124=0,0,1)+IF(F143=0,0,1)+IF(F163=0,0,1)+IF(F182=0,0,1)+IF(F202=0,0,1))","v":523.7},{"$f":"(G25+G44+G64+G83+G104+G124+G143+G163+G182+G202)/(IF(G25=0,0,1)+IF(G44=0,0,1)+IF(G64=0,0,1)+IF(G83=0,0,1)+IF(G104=0,0,1)+IF(G124=0,0,1)+IF(G143=0,0,1)+IF(G163=0,0,1)+IF(G182=0,0,1)+IF(G202=0,0,1))","v":18},17.3,72.8,519.9,null,{"$f":"(L25+L44+L64+L83+L104+L124+L143+L163+L182+L202)/(IF(L25=0,0,1)+IF(L44=0,0,1)+IF(L64=0,0,1)+IF(L83=0,0,1)+IF(L104=0,0,1)+IF(L124=0,0,1)+IF(L143=0,0,1)+IF(L163=0,0,1)+IF(L182=0,0,1)+IF(L202=0,0,1))","v":69.43000000000002}]